| SyAddress |
| Logical Entity Name | SyAddress |
| Default Table Name | SyAddress |
| Physical Only | NO |
| Definition | |
| Note |
| SyAddress Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| SyStudentID | int | NO | ||
| AdEnrollID | int | NO | ||
| SyAddrTypeID | int | NO | ||
| LastName | varchar(25) | NO | ||
| FirstName | varchar(25) | NO | ||
| Addr1 | varchar(255) | NO | ||
| Addr2 | varchar(35) | NO | ||
| City | char(25) | NO | ||
| State | char(2) | NO | ||
| Zip | char(20) | NO | ||
| Country | varchar(50) | YES | ||
| Phone | char(16) | NO | ||
| YearsAtAddress | numeric(9, 1) | YES | ||
| RelationToStudent | varchar(30) | YES | ||
| YearsKnownStudent | numeric(9, 1) | YES | ||
| ReferenceConfirmed | char(1) | YES | ||
| DateReferenceConfirmed | datetime | YES | ||
| Employer | varchar(50) | YES | ||
| WorkPhone | char(16) | YES | ||
| Comments | text | YES | ||
| SSN | char(11) | YES | ||
| PrintedOnMasterPN | char(1) | YES | ||
| PrintedOnPlusPN | char(1) | YES | ||
| ClaimStudentAsDependent | char(1) | YES | ||
| ModFlag | char(1) | NO | ||
| Userid | int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
SyAddressID |
int | NO | ||
| varchar(50) | YES | |||
| SecondPhone | char(16) | YES | ||
| SyCountryID | int | YES | ||
| syZoneID | int | YES | ||
| ReferenceNumber | int | NO | ||
| BeginDate | datetime | YES | ||
| EndDate | datetime | YES | ||
| Yearly | bit | NO | ||
| SyCountyID | int | YES | ||
AmTitleID |
int | YES | ||
| SourceSystem | char(1) | YES | ||
| PlusReferenceNumber | int | NO | ||
| CrmSuppressFlag | bit | NO | ||
| FullName | AS ((ltrim(rtrim([LastName]))+', ')+ltrim(rtrim(isnull([FirstName],'')))) | |||
| OtherPhone | char(10) | YES | ||
| OtherEmail | char(10) | YES | ||
| MobileNumber | char(10) | YES |
| SyAddress Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SyAddress_SyAddressID_U_C_IDX | PrimaryKey | SyAddressID |
| SyAddress Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| amTitle | Non-Identifying | Zero or One to Zero or More | FK_SyAddress_AmTitleID_AmTitle_AmTitleID | AmTitleID | NO | YES |
| Child Relationships: |
| SyAddress Check Constraints |
| Check Constraint Name | CheckConstraint |